package wyh.pojo;

/**
 * 查询出所有服务记录，并显示对应的关联陪诊员、关联患者、预约日期以及服务记录表的全部字段
 *
 *SELECT
 *     sr.*,
 *     p.name AS patient_name,
 *     e.name AS escort_name,
 *     a.date AS appointment_date
 * FROM
 *     servicerecord sr
 *         LEFT JOIN
 *     appointment a ON sr.appointmentId = a.appointmentId
 *         LEFT JOIN
 *     patientinfo p ON sr.patientId = p.patientId
 *         LEFT JOIN
 *     escortinfo e ON sr.escortId = e.escortId;
 */

import lombok.Data;

import java.io.Serializable;
import java.math.BigDecimal;
import java.util.Date;

@Data
public class ServiceRecord2 {
    private Integer serviceRecordId;
    private Integer appointmentId;
    private Integer patientId;
    private Integer escortId;
    private Date serviceStartTime;
    private Date serviceEndTime;
    private String serviceContent;
    private String serviceEvaluation;
    private BigDecimal serviceFee;//二进制浮点数的精度问题，能够保证在进行小数计算时的准确性,适合用于处理服务费用这种需要精确计算的场景
    private String patient_name;
    private String escort_name;
}